 /*  SAS Data Definition File */
 /*  Created by ddltox on Dec 02, 2009  (Wed 11:01 AM PST) */
 /*  DDL source file: "ocs01/ocs01.ddl". */

/* DDL indicates that dataset record length (reclen) is 83 columns. */

TITLE "Special Survey of Orange County 2001";
FILENAME INDATA "    ";    /* Put name of data file between quotes */
LIBNAME LIBRARY "    ";    /* Put directory of data library between quotes */

PROC  FORMAT LIB=LIBRARY;
  VALUE q1ffffff  1='single, detached' 2='attached' 3='apartment' 
                  4='mobile home' 5='other' 8='dk' 9='refuse' ;
  VALUE q2ffffff  1='own' 2='rent' 8='dk' 9='refuse' ;
  VALUE q3ffffff  1='very satisfied' 2='satisfied' 3='dissatisfied' 
                  4='very dissatisfied' 8='dk' 9='refuse' ;
  VALUE q4ffffff  1='very satisfied' 2='satisfied' 3='dissatisfied' 
                  4='very dissatisfied' 8='dk' 9='refuse' ;
  VALUE q5ffffff  1='excellent' 2='good' 3='fair' 4='poor' 8='dk' 9='refuse' ;
  VALUE q6ffffff  1='excellent' 2='good' 3='fair' 4='poor' 8='dk' 9='refuse' ;
  VALUE q7ffffff  1='excellent' 2='good' 3='fair' 4='poor' 8='dk' 9='refuse' ;
  VALUE q8ffffff  1='excellent' 2='good' 3='fair' 4='poor' 8='dk' 9='refuse' ;
  VALUE q9ffffff  1='growing rapidly' 2='growing slowly' 3='staying same' 
                  4='declining' 8='dk' 9='refuse' ;
  VALUE q10fffff  1='too strict' 2='about right' 3='not strict enough' 8='dk' 
                  9='refuse' ;
  VALUE q11fffff  1='big problem' 2='somewhat problem' 3='not problem' 8='dk' 
                  9='refuse' ;
  VALUE q12fffff  1='big problem' 2='somewhat problem' 3='not problem' 8='dk' 
                  9='refuse' ;
  VALUE q13fffff  1='big problem' 2='somewhat problem' 3='not problem' 8='dk' 
                  9='refuse' ;
  VALUE q14fffff  1='big problem' 2='somewhat problem' 3='not problem' 8='dk' 
                  9='refuse' ;
  VALUE q15fffff  1='major cause' 2='minor cause' 8='dk' 9='refuse' ;
  VALUE q16fffff  1='major cause' 2='minor cause' 8='dk' 9='refuse' ;
  VALUE q17fffff  1='major cause' 2='minor cause' 8='dk' 9='refuse' ;
  VALUE q18fffff  1='does' 2='does not' 8='dk' 9='refuse' ;
  VALUE q19fffff  1='schools' 2='immigration' 3='el toro' 4='crime' 5='jobs' 
                  6='health care' 7='taxes' 8='local govt' 9='electricity' 
                  10='environment' 11='beach/water pollution' 12='poverty' 
                  13='traffic' 14='growth' 15='guns' 16='housing' 17='drugs' 
                  18='govt regs' 19='water' 20='other (specify)' 98='dk' 
                  99='refuse' ;
  VALUE q20fffff  1='excellent' 2='good' 3='fair' 4='poor' 8='dk' 9='refuse' ;
  VALUE q21fffff  1='excellent' 2='good' 3='fair' 4='poor' 8='dk' 9='refuse' ;
  VALUE q22fffff  1='very well' 2='somewhat well' 3='somewhat badly' 
                  4='very badly' 8='dk' 9='refuse' ;
  VALUE q23fffff  1='excellent' 2='good' 3='fair' 4='poor' 8='dk' 9='refuse' ;
  VALUE q24fffff  1='a lot' 2='some' 3='very little' 4='none' 8='dk' 
                  9='refuse' ;
  VALUE q25fffff  1='a lot' 2='some' 3='very little' 4='none' 8='dk' 
                  9='refuse' ;
  VALUE q26fffff  1='approve' 2='disapprove' 8='dk' 9='refuse' ;
  VALUE q27fffff  1='favor' 2='oppose' 8='dk' 9='refuse' ;
  VALUE q28fffff  1='favor' 2='oppose' 8='dk' 9='refuse' ;
  VALUE q29fffff  1='yes' 2='no' 8='dk' 9='refuse' ;
  VALUE q30fffff  1='full-time' 2='part time' 3='not employed' 8='dk' 
                  9='refuse' ;
  VALUE q31fffff  1='drive alone' 2='carpool' 3='employer vanpool' 
                  4='pub transit' 5='other' 8='dk' 9='refuse' ;
  VALUE q32fffff  1='no problem' 2='somewhat problem' 3='great problem' 
                  8='dk' 9='refuse' ;
  VALUE q33fffff  1='light rail' 2='widening freeways' 3='expanding bus' 
                  4='carpool lanes' 5='other' 8='dk' 9='refuse' ;
  VALUE q34fffff  1='good thing' 2='bad thing' 3='no diff' 8='dk' 9='refuse' ;
  VALUE q35fffff  1='favor' 2='oppose' 8='dk' 9='refuse' ;
  VALUE q36fffff  1='good thing' 2='bad thing' 3='no diff' 8='dk' 9='refuse' ;
  VALUE q37fffff  1='births to residents' 2='intl immig' 3='dom immig' 
                  4='state & loc policies' 5='other (specify)' 8='dk' 
                  9='refuse' ;
  VALUE q38fffff  1='traffic' 2='housing costs' 3='pollution' 
                  4='loss of space' 5='other (specify)' 8='dk' 9='refuse' ;
  VALUE q39fffff  1='better economy' 2='diversity' 3='services & amenities' 
                  4='tax revenue' 5='other (specify)' 8='dk' 9='refuse' ;
  VALUE q40fffff  1='more desirable' 2='less desirable' 3='no diff' 8='dk' 
                  9='refuse' ;
  VALUE q41fffff  1='better off' 2='worse off' 3='same' 8='dk' 9='refuse' ;
  VALUE q42fffff  1='better off' 2='worse off' 3='same' 8='dk' 9='refuse' ;
  VALUE q43fffff  1='good times' 2='bad times' 8='dk' 9='refuse' ;
  VALUE q44fffff  1='good times' 2='unemp/depress' 8='dk' 9='refuse' ;
  VALUE q45fffff  1='good time' 2='bad time' 8='dk' 9='refuse' ;
  VALUE q46fffff  1='yes, often' 2='yes, sometimes' 3='no' 9='dk/refuse' ;
  VALUE q47fffff  1='Yes, often' 2='Yes, sometimes' 3='No' 
                  7='Do not use computers' 9='dk/refuse' ;
  VALUE q48fffff  1='yes, often use' 2='yes, sometimes use' 
                  3='yes, never use' 4='no' 9='dk/refuse' ;
  VALUE q49fffff  1='democrat' 2='republican' 3='other' 4='independent' 
                  5='not registered' 9='refuse' ;
  VALUE q50fffff  1='Very liberal' 2='Somewhat liberal' 
                  3='Middle-of-the-road' 4='Somewhat conservative' 
                  5='Very conservative' 8='do not know' 9='refuse' ;
  VALUE q51fffff  1='approve' 2='disapprove' 8='dk' 9='refuse' ;
  VALUE q52fffff  1='approve' 2='disapprove' 8='dk' 9='refuse' ;
  VALUE q53fffff  1='approve' 2='disapprove' 8='dk' 9='refuse' ;
  VALUE q54fffff  1='approve' 2='disapprove' 8='dk' 9='refuse' ;
  VALUE q55fffff  1='18 to 24' 2='25 to 34' 3='35 to 44' 4='45 to 54' 
                  5='55 to 64' 6='65 or older' 9='refuse' ;
  VALUE q56fffff  1='yes, children in public school' 
                  2='yes, no children in public school' 3='no' 9='refuse' ;
  VALUE q57fffff  1='Some high school or less' 2='High school graduate' 
                  3='Some college' 4='College graduate' 5='Post-graduate' 
                  9='refuse' ;
  VALUE q59fffff  1='Under $20,000' 2='$20,000 to $39,999' 
                  3='$40,000 to $59,999' 4='$60,000 to $79,999' 
                  5='$80,000 to $99,999' 6='100,000 or more' 9='refuse' ;
  VALUE q60fffff  1='Asian' 2='Black or African-American' 
                  3='Hispanic or Latino' 
                  4='Caucasian or White and not Hispanic' 5='other (specify)' 
                  9='dk/refuse' ;
  VALUE q61fffff  1='yes' 2='no' 9='refuse' ;
  VALUE sex       1='Male' 2='Female' ;
  VALUE language  20='Spanish' 83='English' ;
  VALUE region1f  1='north w/o newport beach' 2='south' ;
  VALUE region2f  1='north w/ newport beach' 2='south' ;
  VALUE yearffff  2001='Year Of Survey' ;
RUN;

DATA IN (LABEL="Special Survey of Orange County 2001");
  INFILE INDATA LRECL=83;
  INPUT
    #1  CASEID 1-4              WEIGHT 5-8 .2           Q1 9                    
        Q2 10                   Q3 11                   Q4 12                   
        Q5 13                   Q6 14                   Q7 15                   
        Q8 16                   Q9 17                   Q10 18                  
        Q11 19                  Q12 20                  Q13 21                  
        Q14 22                  Q15 23                  Q16 24                  
        Q17 25                  Q18 26                  Q19 27-28               
        Q20 29                  Q21 30                  Q22 31                  
        Q23 32                  Q24 33                  Q25 34                  
        Q26 35                  Q27 36                  Q28 37                  
        Q29 38                  Q30 39                  Q31 40                  
        Q32 41                  Q33 42                  Q34 43                  
        Q35 44                  Q36 45                  Q37 46                  
        Q38 47                  Q39 48                  Q40 49                  
        Q41 50                  Q42 51                  Q43 52                  
        Q44 53                  Q45 54                  Q46 55                  
        Q47 56                  Q48 57                  Q49 58                  
        Q50 59                  Q51 60                  Q52 61                  
        Q53 62                  Q54 63                  Q55 64                  
        Q56 65                  Q57 66                  Q58 67-68               
        Q59 69                  Q60 70                  Q61 71                  
        SEX 72                  DATE 73-75              LANGUAGE 76-77          
        REGION1 78              REGION2 79              YEAR 80-83              
        ;

  LABEL
   CASEID  = 'Respondent ID'
   WEIGHT  = 'Weight'
   Q1      = 'Residence type'
   Q2      = 'Own current residence?'
   Q3      = 'Satisfied with your residence?'
   Q4      = 'Satisfied with your neighborhood?'
   Q5      = 'Satisfied with local freeways, streets, roads?'
   Q6      = 'Satisfied with local parks & beaches?'
   Q7      = 'Satisfied with local police?'
   Q8      = 'Satisfied with local public schools?'
   Q9      = 'Local growth rate'
   Q10     = 'Growth regulations'
   Q11     = 'Traffic congestion'
   Q12     = 'Population growth and development'
   Q13     = 'Availability of affordable housing'
   Q14     = 'Lack of job opportunities'
   Q15     = 'Government misspendingng'
   Q16     = 'Rapid growth'
   Q17     = 'Lack of public transit'
   Q18     = 'Local government funding'
   Q19     = 'Most important issue facing Orange County?'
   Q20     = 'Orange County economy'
   Q21     = 'Home as investment'
   Q22     = 'Quality of life'
   Q23     = 'County government performance'
   Q24     = 'County''s attention paid to people'
   Q25     = 'County wasting taxes'
   Q26     = 'County & El Toro'
   Q27     = 'Favor El Toro Great airport?'
   Q28     = 'El Toro airport proposal'
   Q29     = 'El Toro Great Park initiative'
   Q30     = 'Current employment status'
   Q31     = 'How do you commute to work?'
   Q32     = 'Commute traffic'
   Q33     = 'Transit projects'
   Q34     = 'Tollroads?'
   Q35     = 'Foothill tollroad south?'
   Q36     = 'Orange County census'
   Q37     = 'Biggest growth factor'
   Q38     = 'Most negative consequence of growth'
   Q39     = 'Most positive consequence of growth'
   Q40     = 'Orange County after growth?'
   Q41     = 'Financially better off than last year?'
   Q42     = 'Better off next year?'
   Q43     = 'U.S. business conditions next 12 months'
   Q44     = 'U.S. Business conditions next 5 years'
   Q45     = 'Major household purchases'
   Q46     = 'Use a computer?'
   Q47     = 'Use the internet?'
   Q48     = 'Have a computer at home?'
   Q49     = 'Party registration'
   Q50     = 'Political identification'
   Q51     = 'Bush as president?'
   Q52     = 'Bush on economy'
   Q53     = 'Davis as governor?'
   Q54     = 'Davis on electricity?'
   Q55     = 'Age (range)'
   Q56     = 'Have kids in public school'
   Q57     = 'Last grade of school completed'
   Q58     = 'City or community of residence?'
   Q59     = 'Income (range)'
   Q60     = 'Race and ethnicity'
   Q61     = 'Willing to talk about these questions?'
   SEX     = 'Gender (sex)'
   DATE    = 'Interview date'
   LANGUAGE= 'Language of interview'
   REGION1 = 'OC Geographic Region'
   REGION2 = 'OC Geographic Region'
   YEAR    = 'Year of interview'
        ;

  FORMAT Q1 q1ffffff. Q2 q2ffffff. Q3 q3ffffff. 
         Q4 q4ffffff. Q5 q5ffffff. Q6 q6ffffff. 
         Q7 q7ffffff. Q8 q8ffffff. Q9 q9ffffff. 
         Q10 q10fffff. Q11 q11fffff. Q12 q12fffff. 
         Q13 q13fffff. Q14 q14fffff. Q15 q15fffff. 
         Q16 q16fffff. Q17 q17fffff. Q18 q18fffff. 
         Q19 q19fffff. Q20 q20fffff. Q21 q21fffff. 
         Q22 q22fffff. Q23 q23fffff. Q24 q24fffff. 
         Q25 q25fffff. Q26 q26fffff. Q27 q27fffff. 
         Q28 q28fffff. Q29 q29fffff. Q30 q30fffff. 
         Q31 q31fffff. Q32 q32fffff. Q33 q33fffff. 
         Q34 q34fffff. Q35 q35fffff. Q36 q36fffff. 
         Q37 q37fffff. Q38 q38fffff. Q39 q39fffff. 
         Q40 q40fffff. Q41 q41fffff. Q42 q42fffff. 
         Q43 q43fffff. Q44 q44fffff. Q45 q45fffff. 
         Q46 q46fffff. Q47 q47fffff. Q48 q48fffff. 
         Q49 q49fffff. Q50 q50fffff. Q51 q51fffff. 
         Q52 q52fffff. Q53 q53fffff. Q54 q54fffff. 
         Q55 q55fffff. Q56 q56fffff. Q57 q57fffff. 
         Q59 q59fffff. Q60 q60fffff. Q61 q61fffff. 
         SEX sex. LANGUAGE language. REGION1 region1f. 
         REGION2 region2f. YEAR yearffff.  ;

/* md, min and max specifications were translated  */
/* into the following "IF" statements:           */

IF (Q1 = 8 OR Q1 = 9) THEN Q1 = .;
IF (Q2 = 8 OR Q2 = 9) THEN Q2 = .;
IF (Q3 = 8 OR Q3 = 9) THEN Q3 = .;
IF (Q4 = 8 OR Q4 = 9) THEN Q4 = .;
IF (Q5 = 9) THEN Q5 = .;
IF (Q6 = 9) THEN Q6 = .;
IF (Q7 = 9) THEN Q7 = .;
IF (Q8 = 9) THEN Q8 = .;
IF (Q9 = 8 OR Q9 = 9) THEN Q9 = .;
IF (Q10 = 8 OR Q10 = 9) THEN Q10 = .;
IF (Q11 = 9) THEN Q11 = .;
IF (Q12 = 9) THEN Q12 = .;
IF (Q13 = 9) THEN Q13 = .;
IF (Q14 = 9) THEN Q14 = .;
IF (Q15 = 9) THEN Q15 = .;
IF (Q16 = 9) THEN Q16 = .;
IF (Q17 = 9) THEN Q17 = .;
IF (Q18 = 9) THEN Q18 = .;
IF (Q19 = 99) THEN Q19 = .;
IF (Q20 = 9) THEN Q20 = .;
IF (Q21 = 9) THEN Q21 = .;
IF (Q22 = 8 OR Q22 = 9) THEN Q22 = .;
IF (Q23 = 9) THEN Q23 = .;
IF (Q24 = 9) THEN Q24 = .;
IF (Q25 = 9) THEN Q25 = .;
IF (Q26 = 9) THEN Q26 = .;
IF (Q27 = 9) THEN Q27 = .;
IF (Q28 = 9) THEN Q28 = .;
IF (Q29 = 9) THEN Q29 = .;
IF (Q30 = 9) THEN Q30 = .;
IF (Q31 = 8 OR Q31 = 9) THEN Q31 = .;
IF (Q32 = 8 OR Q32 = 9) THEN Q32 = .;
IF (Q33 = 8 OR Q33 = 9) THEN Q33 = .;
IF (Q34 = 9) THEN Q34 = .;
IF (Q35 = 9) THEN Q35 = .;
IF (Q36 = 9) THEN Q36 = .;
IF (Q37 = 9) THEN Q37 = .;
IF (Q38 = 9) THEN Q38 = .;
IF (Q39 = 9) THEN Q39 = .;
IF (Q40 = 9) THEN Q40 = .;
IF (Q41 = 9) THEN Q41 = .;
IF (Q42 = 9) THEN Q42 = .;
IF (Q43 = 9) THEN Q43 = .;
IF (Q44 = 9) THEN Q44 = .;
IF (Q45 = 9) THEN Q45 = .;
IF (Q46 = 8 OR Q46 = 9) THEN Q46 = .;
IF (Q47 = 8 OR Q47 = 9) THEN Q47 = .;
IF (Q48 = 8 OR Q48 = 9) THEN Q48 = .;
IF (Q49 = 8 OR Q49 = 9) THEN Q49 = .;
IF (Q50 = 9) THEN Q50 = .;
IF (Q51 = 9) THEN Q51 = .;
IF (Q52 = 9) THEN Q52 = .;
IF (Q53 = 9) THEN Q53 = .;
IF (Q54 = 9) THEN Q54 = .;
IF (Q55 = 9) THEN Q55 = .;
IF (Q56 = 9) THEN Q56 = .;
IF (Q57 = 9) THEN Q57 = .;
IF (Q58 = 99) THEN Q58 = .;
IF (Q59 = 9) THEN Q59 = .;
IF (Q60 = 9) THEN Q60 = .;

PROC DATASETS;
  CONTENTS DATA=IN POSITION;
  TITLE 'CONTENTS OF ALL VARIABLES';
RUN;
